package AddProduct;
/**
 * This is a final class for constants.
 * Here are all slq statements to batabase. 
 * @author desso_000
 *
 */
public final class SQLStatements {
	  public  static  final String STATMENT_FOR_PRODUCERS = " SELECT * FROM PRODUCERS ";
	  public  static  final String STATMENT_FOR_BRANDS = " SELECT * FROM BRANDS ";
	  public  static  final String STATMENT_FOR_CATEGORIES = " SELECT ID, NAME FROM CATEGORIES ";
	  public  static  final String STATMENT_FOR_MATERIALS = " SELECT * FROM MATERIALS ";
	  public  static  final String STATMENT_FOR_COLORS = " SELECT ID, NAME FROM COLORS ";
	  public  static  final String STATMENT_FOR_SIZES = " SELECT * FROM SIZES ";
	  public  static  final String STATMENT_FOR_ITEMS = " SELECT I.ID, I.DESCRIPTION AS ITEM_NAME, B.DESCRIPTION AS BRAND  FROM ITEMS I"
                                                      + " JOIN BRANDS B ON (I.BRAND_ID = B.ID) ";
	  public  static  final String INSERT_INTO_ITEM_MATERIALS_TABLE = " INSERT INTO ITEM_MATERIALS VALUES (?,?,?) ";
	  public  static  final String INSERT_INTO_ITEM_CATEGORIES_TABLE = " INSERT INTO ITEM_CATEGORIES VALUES (?,?) ";
	  //public  static  final String INSERT_INTO_CLOTHING_INVENTORY_TABLE = " INSERT INTO CLOTHING_INVENTORY VALUES (?,?,?,?) ";
	  public  static  final String INSERT_INTO_CLOTHING_INVENTORY_TABLE = " INSERT INTO CLOTHING_INVENTORY(item_id, size_id, color_id, count) VALUES (?,?,?,?) ";
	  //public  static  final String INSERT_INTO_ITEMS_TABLE = " INSERT INTO ITEMS VALUES (?,?,?,?,?,?,?) ";
	  public  static  final String INSERT_INTO_ITEMS_TABLE = " INSERT INTO ITEMS(description,price,promotional_price, whole_sale_price,supplier_id, producer_id, brand_id) VALUES (?,?,?,?,?,?,?) ";
	  
	  //public  static  final String INSERT_INTO_PRESENTS_TABLE = " INSERT INTO PRESENTS VALUES (?,?,?) ";
	  public  static  final String INSERT_INTO_PRESENTS_TABLE = " INSERT INTO PRESENTS(description,figure_path,count) VALUES (?,?,?) ";
	  public  static  final String INSERT_INTO_ITEM_PRESENTS_TABLE = " INSERT INTO ITEM_PRESENTS VALUES (?,?) ";
}
